package com.hngs.dao;

import com.hngs.model.Category;
import com.hngs.model.CategoryQuery;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface CategoryDao {
   // @Select("select * from 202_category")
    public List<Category> findAll();
//    @Select("select * from 202_category where id=#{id} and name=#{name}")
//    public List<Category> findById(@Param("id") Integer id,@Param("name") String name);

    public List<Category> select(CategoryQuery query);
    //类目得添加
    public int insert(Category category);
    //类目得修改
    public int update(Category category);
    //类目得软删除
    public int updateStatus(@Param("id") Integer id, @Param("status") int status);

}

